UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'We8FQq4GY8LmUmzkKDhbCF+lE/+4RUiVFt0KVcYdLjs='
WHERE
key_id = '943e58468132b8ac5e34c84c95a22cc67c0fdd748c9b5675debdc7b2a4b182a2'
AND (
token = 'We8FQq4GY8LmUmzkKDhbCF+lE/+4RUiVFt0KVcYdLjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)