UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1pwrDM6b3lFeiJmeRbIstCMF6kOykM/prsSK4r/lEE='
WHERE
key_id = '65111f9f7abcc9fd03fcd0fd7751d5c1412490364daa95ce7cdce991c0023d96'
AND (
token = 'd1pwrDM6b3lFeiJmeRbIstCMF6kOykM/prsSK4r/lEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)