UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUzR6Zz8XsvGVpr4CubaL2q5rk4OWoEd0w9r1Jq8aeA='
WHERE
key_id = 'bbc31eb39731a61a6a308a8c5ccc5912d9738fe848df92af6a82cb834a7678b9'
AND (
token = 'hUzR6Zz8XsvGVpr4CubaL2q5rk4OWoEd0w9r1Jq8aeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)