UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '32L1tLPCqbCBNPw2wkQunS6KRUp1KLhEotWvb6AqujY='
WHERE
key_id = 'e6312373a8f0282d8410f8fb62298a48a433ab7dc8a50337a3352d58cf59e376'
AND (
token = '32L1tLPCqbCBNPw2wkQunS6KRUp1KLhEotWvb6AqujY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)