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