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