UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '71PjYhaJyN6bnhyggfOyy4IvlGo8Ts5vrwAfqJJja4s='
WHERE
key_id = '2fa829a1496ef6c8dbadf9c532a437d899258ff3236cf71324691340154105d7'
AND (
token = '71PjYhaJyN6bnhyggfOyy4IvlGo8Ts5vrwAfqJJja4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)