UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnKgzrVwDn0L2DSA9MKYYqTl3W6zEmZABdB6lBqO6tI='
WHERE
key_id = '994c1218c3329dd16a157fbc7d957e8392d081031b887ba76025eae2ab09f1d3'
AND (
token = 'ZnKgzrVwDn0L2DSA9MKYYqTl3W6zEmZABdB6lBqO6tI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)