UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+2URbnmKG/0WC07rbj7J8xOw1thxwSTMKSXz/TUH3U='
WHERE
key_id = 'a07ccf41a8272f50fadd73b27cdafc13449ad0a25ae0fc14b1980c8c0bed8c4d'
AND (
token = 'x+2URbnmKG/0WC07rbj7J8xOw1thxwSTMKSXz/TUH3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)