UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9RWUj9OFvMKDNq0pHAdKJrL78IYIhRVU6odFLjYvwg='
WHERE
key_id = '14957f8e017e0b3723b734fdf081db283d102c86dd92f37d5dd9fd914ae8a286'
AND (
token = 'J9RWUj9OFvMKDNq0pHAdKJrL78IYIhRVU6odFLjYvwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)