UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bd6TWclQMobhhGZOGsObmiYLmbmI38lwyGjykncBddI='
WHERE
key_id = '1afafc153d263989f6c7429d49424f6216dd9000ce7fd339e9fb7df842e9db19'
AND (
token = 'Bd6TWclQMobhhGZOGsObmiYLmbmI38lwyGjykncBddI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)