UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4DGyIIQfvFWFyFW7X8uc+auhlEMnqhGADrmnoJJDU7U='
WHERE
key_id = '478de907ae82f82879f024d6f3037840404ebf4c0ae1281dabc78f6adfe04360'
AND (
token = '4DGyIIQfvFWFyFW7X8uc+auhlEMnqhGADrmnoJJDU7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)