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