UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VUA1A3Nld8cqfcwl5CiDYHGCRBsZI0BGCJlggc3aQ7U='
WHERE
key_id = '00eccd103b8c7807316afa3c364aa88a0b2b905769c543b03c426ad6990328d1'
AND (
token = 'VUA1A3Nld8cqfcwl5CiDYHGCRBsZI0BGCJlggc3aQ7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)