UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJn3ccF+LXSN2k/deFiHcWo2e3Yb3KosVCYc7r4nk2s='
WHERE
key_id = '1832593a04f0b09c294eb66f32bf28615f06e029d2c95ff44253e3be89b73668'
AND (
token = 'NJn3ccF+LXSN2k/deFiHcWo2e3Yb3KosVCYc7r4nk2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)