UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QABfG3t6Fb40Z6RY3kKGUYdGThEYv6Fz2Z18iy6UVJg='
WHERE
key_id = 'cfe1c1dd7c253df9e8e4ae0601cc722fd17c233e4e335adbfaee2c430c1bc6b6'
AND (
token = 'QABfG3t6Fb40Z6RY3kKGUYdGThEYv6Fz2Z18iy6UVJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)