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