UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzBGWxtX08l2xU9y1pFKiom7CrcluXtaQssENDb2aKc='
WHERE
key_id = '767653932aad2f78caf2ff77d5f7416d52e10b866870659c4ce410494cf3cd2c'
AND (
token = 'DzBGWxtX08l2xU9y1pFKiom7CrcluXtaQssENDb2aKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)