UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jzE46k48W7SJ3LYQVl6FPEgVR5WABe+1YRkJ5BRUEzU='
WHERE
key_id = 'a6e43e6dd9354c87463f38b2c86c89d65140e1c9144452ac46bf60949b1d2bb8'
AND (
token = 'jzE46k48W7SJ3LYQVl6FPEgVR5WABe+1YRkJ5BRUEzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)