UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NXW0tukbCL4GTzhL/A6oqSHQcFH3BWZQjpH3Bc+AYQ='
WHERE
key_id = '224ca7404965e3c892110ab5b15f4aba16e03375926bf70fb637dd7fb8bbfe8e'
AND (
token = '0NXW0tukbCL4GTzhL/A6oqSHQcFH3BWZQjpH3Bc+AYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)