UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CJNfa8kA5PeQpehK5gLBeYjaHJgrxDo+/SKdh5WrO8='
WHERE
key_id = '9690247cb6df502c28a6a1cf53d863fd1f801d6e2cf49fbfd824678d82a3a8d8'
AND (
token = '8CJNfa8kA5PeQpehK5gLBeYjaHJgrxDo+/SKdh5WrO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)