UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1jjYc2hhcgq3VbwsfkkFJFygxoJzF5im+0DOsr4TjA='
WHERE
key_id = 'ad42366f4db37f03106b20a04a9999089e03daf2275927a7c25796c4f2b6446e'
AND (
token = 'X1jjYc2hhcgq3VbwsfkkFJFygxoJzF5im+0DOsr4TjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)