UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHtpTdYDZvBs/GFkjyU6aG4asmLDT0WQqwI2PNnD5rM='
WHERE
key_id = '1ad490a87e15915312fdc03d182e3bda07a94c16f8b7862ede111d28c37f9bdf'
AND (
token = 'xHtpTdYDZvBs/GFkjyU6aG4asmLDT0WQqwI2PNnD5rM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)