UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLFHCwhadMAJ6wW0brFhiHUDuBtruIyePHMQXZRmMNQ='
WHERE
key_id = '6b8bb271ce5f82cfece256b0642f1fafe6c70a5d1eb44d51b22972d1fb19d314'
AND (
token = 'XLFHCwhadMAJ6wW0brFhiHUDuBtruIyePHMQXZRmMNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)