UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VnDYsJDunNjGXL5GVgmGMgE0aH8sJadzXTxNzGlEsc='
WHERE
key_id = 'a93ef2fa0e4f96fccf8504b5a8f33169a09f8ab2962072e7055d96e923e4c8a7'
AND (
token = '9VnDYsJDunNjGXL5GVgmGMgE0aH8sJadzXTxNzGlEsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)