UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c3VNBEq18rTW8PKwTAzALm/4w4efI3WAec/mFVjol1g='
WHERE
key_id = 'd40c510a67d8ae3d617f90947974e3d843e7c67c3f8b7c43edb801170371363c'
AND (
token = 'c3VNBEq18rTW8PKwTAzALm/4w4efI3WAec/mFVjol1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)