UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lrDIzjz5DkgQmDKhFIHttdPzXPyrKm+hd00j3Mq+OA8='
WHERE
key_id = 'afdfc3653a14abeba5944b66f9a781f1942056c0da16ae71a45050f959794439'
AND (
token = 'lrDIzjz5DkgQmDKhFIHttdPzXPyrKm+hd00j3Mq+OA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)