UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZVFg6b/g8LupqgwaPH1ZoiydW/TebulaAckK6QkUTc='
WHERE
key_id = 'ba3910246433d94bc5a1463c670dc5a692e8fc388b58e45c7785f7bc1bf7a2ed'
AND (
token = '0ZVFg6b/g8LupqgwaPH1ZoiydW/TebulaAckK6QkUTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)