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