UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ybK5tk1Xa+ZQRp5ZTFUQgLmjfRunATq6qw8NkPWO0g='
WHERE
key_id = '9cd72142749bc6922b0777faabd597fdce238941ca8daa4c91d8b5bc36b65669'
AND (
token = '2ybK5tk1Xa+ZQRp5ZTFUQgLmjfRunATq6qw8NkPWO0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)