UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bwX8j8tYZznHTa2k/ltQp3VgSDk64QjH9o3Dl47teaE='
WHERE
key_id = 'd90412114148415e20eb3c91f1f65f595a2563fd0d03e34f2f55abe69c23a9d3'
AND (
token = 'bwX8j8tYZznHTa2k/ltQp3VgSDk64QjH9o3Dl47teaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)