UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6FHea05dM7iGgb9LvWESKlEpVHFyOIwHzMAWxLbNFM='
WHERE
key_id = '3f9e4d6a778f4e5be4e564717daff863e0ea79657d026c3e48238d2f65a19092'
AND (
token = 'H6FHea05dM7iGgb9LvWESKlEpVHFyOIwHzMAWxLbNFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)