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