UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kiQ4JgdhQjQa7RELpNmrKytbPmmWf/+GX46yj6S7izI='
WHERE
key_id = '8c6c79f74357c009d3090c4f1411b1ffe6ca8770207169690a47221600a24952'
AND (
token = 'kiQ4JgdhQjQa7RELpNmrKytbPmmWf/+GX46yj6S7izI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)