UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gQOhX7PVlWjMiO4htt/7zpIhMrdvI9njd0zE7KQa6g='
WHERE
key_id = 'fe5769e9e0888e16405c2b199748480b653d41194e64ddfb0a6384069d79aa95'
AND (
token = '6gQOhX7PVlWjMiO4htt/7zpIhMrdvI9njd0zE7KQa6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)